﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReferencedAssemblies="System.dll&#13;&#10;System.Core.dll&#13;&#10;System.Drawing.dll&#13;&#10;System.Windows.Forms.dll&#13;&#10;System.Data.dll&#13;&#10;System.Xml.dll&#13;&#10;Sungero.Domain.Shared&#13;&#10;Sungero.CoreEntities.Shared&#13;&#10;Sungero.Reporting.Shared&#13;&#10;CommonLibrary&#13;&#10;Sungero.CoreEntities.Server&#13;&#10;Sungero.Company.Shared&#13;&#10;Sungero.Company.Server&#13;&#10;Sungero.Domain.Interfaces&#13;&#10;Sungero.Content.Shared&#13;&#10;Sungero.Workflow.Interfaces&#13;&#10;Sungero.Docflow.Shared&#13;&#10;Sungero.Docflow.Server&#13;&#10;Sungero.Meetings.Shared&#13;&#10;Sungero.Meetings.Server&#13;&#10;Sungero.RecordManagement.Shared&#13;&#10;Sungero.RecordManagement.Server" ReportInfo.CreatorVersion="2020.2.12.0">
  <ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text.RegularExpressions;
using System.Windows.Forms;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;
using Sungero.CoreEntities;
using Sungero.Company;
using Sungero.Docflow;
using Sungero.Meetings;
using Sungero.Domain.Shared;
using Sungero.Core;
using Resources = Sungero.RecordManagement.Reports.Resources;


namespace FastReport
{
  public class ReportScript
  {
  }
}
  </ScriptText>
  <Dictionary>
    <SungeroSqlDataConnection Name="Sungero_Connection" Restrictions="DontModify, DontDelete, HideAllProperties" ConnectionStringExpression="[SungeroConnectionString]">
      <TableDataSource Name="Table" Alias="SourceTable" DataType="System.Int32" Enabled="true" CanEdit="true" SelectCommand="${SelectDataFromTable}">
        <Column Name="Id" DataType="System.Int32" PropName="Column"/>
        <Column Name="ActionItemText" DataType="System.String" PropName="Column"/>
        <Column Name="Author" DataType="System.String" PropName="Column"/>
        <Column Name="State" DataType="System.String" PropName="Column"/>
        <Column Name="PlanDate" DataType="System.String" PropName="Column"/>
        <Column Name="ActualDate" DataType="System.String" PropName="Column"/>
        <Column Name="Overdue" DataType="System.Int32" PropName="Column"/>
        <Column Name="Assignee" DataType="System.String" PropName="Column"/>
        <Column Name="CoAssignees" DataType="System.String" PropName="Column"/>
        <Column Name="DocumentInfo" DataType="System.String" PropName="Column"/>
        <Column Name="Hyperlink" DataType="System.String" PropName="Column"/>
        <Column Name="PlanDateSort" DataType="System.DateTime" PropName="Column"/>
        <CommandParameter Name="ReportSessionId" DataType="16" IsDbType="true" Expression="[ReportSessionId]"/>
      </TableDataSource>
    </SungeroSqlDataConnection>
    <SungeroParameter Name="SungeroConnectionString" Restrictions="DontModify, DontEdit, DontDelete, HideAllProperties, DontShow" Id="12dda7b2-bcbb-423c-add0-d1c887f1769a" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="BeginDate" Id="e9411cd2-0339-44e0-a25e-98dd1259e112" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="EndDate" Id="0ad1723a-6ea5-44db-8c3d-5a2907131adc" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="ExecutiveDisciplineLevel" Id="2a5d4ed3-99b3-42a2-9f1d-65232c2ded3d" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="ClientEndDate" Id="d70901c7-8ba3-40b8-b62d-b462300c064a" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="ReportDate" Id="3dc3cc3c-bfde-41b1-b2ce-39112e758c0e" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="Performer" Id="ac36e512-22e8-4334-926f-cba231a5b1a6" IsRequired="false" IsCollection="false" InternalDataType="Sungero.CoreEntities.IUser, Sungero.Domain.Shared" IsSimpleDataType="false" EntityTypeId="243c2d26-f5f7-495f-9faf-951d91215c77"/>
    <SungeroParameter Name="Department" Id="647f8305-c49b-4534-8a9e-acda2972cc51" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Company.IDepartment, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="61b1c19f-26e2-49a5-b3d3-0d3618151e12"/>
    <SungeroParameter Name="Author" Id="21340b99-8f1a-40df-ab29-e4006eadf992" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Company.IEmployee, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="b7905516-2be5-4931-961c-cb38d5677565"/>
    <SungeroParameter Name="BusinessUnit" Id="9e6c8157-51c2-4d7b-b0ea-d1d54d838268" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Company.IBusinessUnit, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="eff95720-181f-4f7d-892d-dec034c7b2ab"/>
    <SungeroParameter Name="TotalCount" Id="b1c110a6-92eb-4bcd-a53c-02865c32b856" IsRequired="false" IsCollection="false" InternalDataType="System.Int32" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="Completed" Id="584eca40-bcce-4583-9d3c-884d5b57529e" IsRequired="false" IsCollection="false" InternalDataType="System.Int32" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="CompletedInTime" Id="0ed84fc1-35a4-41d9-82a0-3435773a6368" IsRequired="false" IsCollection="false" InternalDataType="System.Int32" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="CompletedOverdue" Id="705bbede-b0e2-47d7-8818-d3922d3c873c" IsRequired="false" IsCollection="false" InternalDataType="System.Int32" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="InProcess" Id="e30f7a6e-593e-454c-a044-c4c72375a9ed" IsRequired="false" IsCollection="false" InternalDataType="System.Int32" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="InProcessOverdue" Id="6ad56418-60ab-4689-82c0-920b33f316e9" IsRequired="false" IsCollection="false" InternalDataType="System.Int32" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="ParamsDescriprion" Id="ee258574-de81-4eec-9cb2-bbfc81db708e" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="ReportSessionId" Id="bdbf8979-5d6d-43e9-8d47-cadf1cb04f20" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="Document" Id="0befb560-c78f-4478-995d-d975fdba0535" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Docflow.IOfficialDocument, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="58cca102-1e97-4f07-b6ac-fd866a8b7cb1"/>
    <SungeroParameter Name="Subheader" Id="e6c669d6-f1d8-4862-b4f6-29e259e93f9d" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="Meeting" Id="cb37754e-bf1d-4cf6-9f68-6d65bc98e518" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Meetings.IMeeting, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="dbc0dd63-4d23-4f41-92ae-cab59bb70c8c"/>
    <SungeroParameter Name="IsMeetingsCoverContext" Id="349c37ba-f99f-4271-9e85-cf429311c03c" IsRequired="false" IsCollection="false" InternalDataType="System.Boolean" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="Header" Id="60379fb0-02b8-4171-8b75-e30863535d92" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="DocumentType" Id="9e0013e7-88bf-41ec-9049-d95fc24ac47b" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Docflow.IDocumentType, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="0896aa80-e1da-4a1e-9485-d172f8e242bc"/>
  </Dictionary>
  <ReportPage Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" TopMargin="25" BottomMargin="15" MirrorMargins="true" FirstPageSource="15" OtherPagesSource="15" Watermark.Font="Arial, 60pt" PrintOnPreviousPage="true">
    <ReportTitleBand Name="ReportTitle1" Width="1047.06" Height="179.55" CanGrow="true">
      <TextObject Name="Text24" Width="529.2" Height="18.9" CanGrow="true" Text="[ParamsDescriprion]" Font="Arial, 10pt"/>
      <TextObject Name="Text25" Left="529.2" Width="519.75" Height="18.9" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.ReportDate] [ReportDate]" Format="Date" Format.Format="d" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Text26" Top="18.9" Width="1048.95" Height="28.35" Text="[Header]" HorzAlign="Center" VertAlign="Center" Font="Arial, 14pt, style=Bold"/>
      <TextObject Name="Text27" Top="47.25" Width="1048.95" Height="18.9" CanGrow="true" Text="[Subheader]" HorzAlign="Center" VertAlign="Center" Font="Arial, 12pt, style=Bold">
        <Formats>
          <DateFormat/>
          <DateFormat/>
        </Formats>
      </TextObject>
      <TextObject Name="Text28" Top="66.15" Width="170.1" Height="85.05" CanBreak="false" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.Statistics]" VertAlign="Bottom" Font="Arial, 10pt"/>
      <TextObject Name="Text2" Left="189" Top="66.15" Width="47.25" Height="85.05" CanBreak="false" Text="[TotalCount]&#13;&#10;[Completed]&#13;&#10;[CompletedOverdue]&#13;&#10;[InProcess]&#13;&#10;[InProcessOverdue]" HorzAlign="Right" VertAlign="Bottom" Font="Arial, 10pt"/>
      <TextObject Name="Text3" Top="151.2" Width="529.2" Height="28.35" CanBreak="false" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.DisciplinePercent] - [ExecutiveDisciplineLevel]" Font="Arial, 10pt"/>
      <TextObject Name="Text4" Left="170.1" Top="66.15" Width="18.9" Height="85.05" CanBreak="false" Text="-&#13;&#10;-&#13;&#10;-&#13;&#10;-&#13;&#10;-" HorzAlign="Center" VertAlign="Bottom" Font="Arial, 10pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="183.55" Width="1047.06" Height="37.8">
      <TextObject Name="Text29" Width="37.8" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.RowNumber]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text30" Left="37.8" Width="47.25" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.Id]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text31" Left="85.05" Width="113.4" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.ActionItem]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text32" Left="198.45" Width="113.4" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.Author]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text33" Left="311.85" Width="85.05" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.Status]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text34" Left="396.9" Width="85.05" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.Deadline]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text35" Left="481.95" Width="85.05" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.ActualDate]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text36" Left="567" Width="75.6" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.Overdue]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text37" Left="642.6" Width="122.85" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.Assignee]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text38" Left="765.45" Width="122.85" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.CoAssignees]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text39" Left="888.3" Width="160.65" Height="37.8" Border.Lines="All" Text="[Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.Document]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
    </PageHeaderBand>
    <DataBand Name="Data3" Top="225.35" Width="1047.06" Height="37.8" CanGrow="true" DataSource="Table">
      <TextObject Name="Text40" Width="37.8" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[Row#]" HorzAlign="Center" Font="Arial, 10pt"/>
      <TextObject Name="Text41" Left="37.8" Width="47.25" Height="37.8" Border.Lines="All" Cursor="Hand" Hyperlink.Expression="[SourceTable.Hyperlink]" CanGrow="true" GrowToBottom="true" Text="[SourceTable.Id]" HorzAlign="Center" Font="Arial, 10pt, style=Underline" TextFill.Color="Blue"/>
      <TextObject Name="Text42" Left="85.05" Width="113.4" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[SourceTable.ActionItemText]" Font="Arial, 10pt">
        <Highlight>
          <Condition Expression="[SourceTable.Overdue] &gt; 0 &amp;&amp; [SourceTable.ActualDate]==&quot;&quot;" Font="Arial, 10pt"/>
        </Highlight>
      </TextObject>
      <TextObject Name="Text43" Left="198.45" Width="113.4" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[SourceTable.Author]" Font="Arial, 10pt"/>
      <TextObject Name="Text44" Left="311.85" Width="85.05" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[SourceTable.State]" Font="Arial, 10pt">
        <Highlight>
          <Condition Expression="[SourceTable.Overdue] &gt; 0 &amp;&amp; [SourceTable.ActualDate] == &quot;&quot;" Font="Arial, 10pt"/>
        </Highlight>
      </TextObject>
      <TextObject Name="Text45" Left="396.9" Width="85.05" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[string.IsNullOrEmpty([SourceTable.PlanDate]) ? Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.IndefiniteDeadline : [SourceTable.PlanDate]]" Format="Date" Format.Format="d" HorzAlign="Center" Font="Arial, 10pt"/>
      <TextObject Name="Text46" Left="481.95" Width="85.05" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[SourceTable.ActualDate]" HorzAlign="Center" Font="Arial, 10pt">
        <Formats>
          <DateFormat/>
          <GeneralFormat/>
        </Formats>
        <Highlight>
          <Condition Expression="[SourceTable.Overdue] &gt; 0 &amp;&amp; [SourceTable.ActualDate] != &quot;&quot;" Font="Arial, 10pt"/>
        </Highlight>
      </TextObject>
      <TextObject Name="Text47" Left="567" Width="75.6" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[IIf([SourceTable.Overdue] == 0, &quot;&quot;, [SourceTable.Overdue] + &quot; &quot; + Sungero.RecordManagement.Reports.Resources.ActionItemsExecutionReport.WorkingDay)]" HorzAlign="Center" Font="Arial, 10pt" TextFill.Color="Red"/>
      <TextObject Name="Text48" Left="642.6" Width="122.85" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[SourceTable.Assignee]" Font="Arial, 10pt"/>
      <TextObject Name="Text49" Left="765.45" Width="122.85" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[SourceTable.CoAssignees]" Font="Arial, 10pt"/>
      <TextObject Name="Text50" Left="888.3" Width="160.65" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[SourceTable.DocumentInfo]" Font="Arial, 10pt"/>
    </DataBand>
    <PageFooterBand Name="PageFooter1" Top="267.15" Width="1047.06" Height="28.35" CanShrink="true">
      <TextObject Name="Text1" Top="9.45" Width="94.5" Height="18.9" Text="[Page]" Font="Arial, 10pt"/>
    </PageFooterBand>
  </ReportPage>
</Report>
